package com.itqf.mapper;

import com.itqf.pojo.Author;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * projectName: mybatisgp8
 *
 * @author: 赵伟风
 * time: 2021/7/30 15:14
 * description:
 */
public interface AuthorMapper {

     @Select("select * from author")
     List<Author> queryByPage();


     @Select("select * from author where a_id > #{id}")
     List<Author> queryById(int id);


     @Insert("insert into author (a_name,a_age) value (#{aName},#{aAge})")
     int insert(Author author);

}
